Statistical modelling

By sorting the spreadsheet first in descending order of EXPTOT and selecting the top 40 cows, and then by opening CS2Data2 again and sorting in descending order of EXP210 and selecting again the top 40 cows, we can produce the additional data files CS2Data3 and CS2Data4.

By further cutting and pasting we can produce the table which shows the relative ranking positions of the top 30 cow using the two methods for defining milk offtake.

We can see that most 'elite' cows are included in both columns, at least down to position 30. 

Just one cow (no. 57) ranked 20 for milk offtake to 210 days did not appear among the top 40 cows ranked for total offtake (see CS2Data4).

 

Total milk offtake(kg) Milk offtake to 210 days (kg)

Rank

COWID

EXPTOT

COWID

EXP210


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

41
174
58
46
62
77
74
39
126
227
433
291
389
159
458
76
92
267
361
81
143
408
27
30
113
152
105
73
189
17

645
639
577
567
545
543
538
536
534
524
520
518
518
515
515
513
512
505
500
497
496
494
490
481
479
479
475
468
466
465

174
41
46
58
291
74
77
81
39
92
76
389
143
159
433
62
267
458
189
57
227
27
361
205
316
127
30
105
152
113

564
556
518
509
507
493
493
491
485
485
481
481
476
470
467
463
462
459
457
453
450
449
449
436
435
433
431
430
425
422


`

  back      Next